﻿CREATE TABLE [dbo].[OperatingSystem] (
    [Caption]                 VARCHAR (200)    NOT NULL,
    [ServicePackMajorVersion] INT              NULL,
    [ServicePackMinorVersion] INT              NULL,
    [OSArchitecture]          VARCHAR (10)     NULL,
    [ServerID]                UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_OperatingSystem] PRIMARY KEY CLUSTERED ([Caption] ASC, [ServerID] ASC),
    CONSTRAINT [FK_OperatingSystem_Server] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);

